Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 4287 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 368.5 KiB |
| Average record size in memory | 88.0 B |
Variable types
| Numeric | 8 |
|---|---|
| DateTime | 2 |
| Text | 1 |
frequency is highly overall correlated with last_visit and 5 other fields | High correlation |
last_visit is highly overall correlated with frequency and 1 other fields | High correlation |
monatary is highly overall correlated with frequency and 4 other fields | High correlation |
recency is highly overall correlated with frequency and 5 other fields | High correlation |
total_items is highly overall correlated with frequency and 4 other fields | High correlation |
total_quantity is highly overall correlated with frequency and 4 other fields | High correlation |
total_unique_items is highly overall correlated with frequency and 4 other fields | High correlation |
monatary is highly skewed (γ1 = 24.25011359) | Skewed |
total_quantity is highly skewed (γ1 = 20.24345495) | Skewed |
customer_id has unique values | Unique |
Reproduction
| Analysis started | 2024-10-01 10:55:14.009198 |
|---|---|
| Analysis finished | 2024-10-01 10:55:41.027806 |
| Duration | 27.02 seconds |
| Software version | ydata-profiling vv4.10.0 |
| Download configuration | config.json |
customer_id
Real number (ℝ)
UNIQUE 
| Distinct | 4287 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15355.474 |
| Minimum | 12346 |
|---|---|
| Maximum | 18287 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.6 KiB |
Quantile statistics
| Minimum | 12346 |
|---|---|
| 5-th percentile | 12696.6 |
| Q1 | 13889.5 |
| median | 15361 |
| Q3 | 16839.5 |
| 95-th percentile | 17988.7 |
| Maximum | 18287 |
| Range | 5941 |
| Interquartile range (IQR) | 2950 |
Descriptive statistics
| Standard deviation | 1700.5656 |
|---|---|
| Coefficient of variation (CV) | 0.11074654 |
| Kurtosis | -1.1938072 |
| Mean | 15355.474 |
| Median Absolute Deviation (MAD) | 1477 |
| Skewness | -0.016714419 |
| Sum | 65828915 |
| Variance | 2891923.2 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 18287 | 1 | < 0.1% |
| 12346 | 1 | < 0.1% |
| 12347 | 1 | < 0.1% |
| 12348 | 1 | < 0.1% |
| 12349 | 1 | < 0.1% |
| 12351 | 1 | < 0.1% |
| 12352 | 1 | < 0.1% |
| 12353 | 1 | < 0.1% |
| 12355 | 1 | < 0.1% |
| 12356 | 1 | < 0.1% |
| Other values (4277) | 4277 |
| Value | Count | Frequency (%) |
| 12346 | 1 | |
| 12347 | 1 | |
| 12348 | 1 | |
| 12349 | 1 | |
| 12351 | 1 | |
| 12352 | 1 | |
| 12353 | 1 | |
| 12355 | 1 | |
| 12356 | 1 | |
| 12357 | 1 |
| Value | Count | Frequency (%) |
| 18287 | 1 | |
| 18286 | 1 | |
| 18285 | 1 | |
| 18284 | 1 | |
| 18283 | 1 | |
| 18281 | 1 | |
| 18280 | 1 | |
| 18279 | 1 | |
| 18278 | 1 | |
| 18277 | 1 |
monatary
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 4225 |
|---|---|
| Distinct (%) | 98.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2034.552 |
| Minimum | 1.55 |
|---|---|
| Maximum | 349164.35 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.6 KiB |
Quantile statistics
| Minimum | 1.55 |
|---|---|
| 5-th percentile | 111.509 |
| Q1 | 308.4 |
| median | 710.98 |
| Q3 | 1723.245 |
| 95-th percentile | 6173.159 |
| Maximum | 349164.35 |
| Range | 349162.8 |
| Interquartile range (IQR) | 1414.845 |
Descriptive statistics
| Standard deviation | 8821.9698 |
|---|---|
| Coefficient of variation (CV) | 4.3360749 |
| Kurtosis | 777.17745 |
| Mean | 2034.552 |
| Median Absolute Deviation (MAD) | 503.13 |
| Skewness | 24.250114 |
| Sum | 8722124.4 |
| Variance | 77827151 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 102 | 3 | 0.1% |
| 165 | 3 | 0.1% |
| 131.25 | 2 | < 0.1% |
| 405 | 2 | < 0.1% |
| 79.9 | 2 | < 0.1% |
| 262.4 | 2 | < 0.1% |
| 317.76 | 2 | < 0.1% |
| 209.4 | 2 | < 0.1% |
| 307.95 | 2 | < 0.1% |
| 429 | 2 | < 0.1% |
| Other values (4215) | 4265 |
| Value | Count | Frequency (%) |
| 1.55 | 1 | |
| 2.95 | 1 | |
| 3.75 | 1 | |
| 6.3 | 1 | |
| 7.49 | 1 | |
| 9.7 | 1 | |
| 10.55 | 1 | |
| 10.95 | 1 | |
| 13.52 | 1 | |
| 13.92 | 1 |
| Value | Count | Frequency (%) |
| 349164.35 | 1 | |
| 248396.5 | 1 | |
| 186849 | 1 | |
| 140378.89 | 1 | |
| 131443.19 | 1 | |
| 84541.17 | 1 | |
| 83282.93 | 1 | |
| 80489.21 | 1 | |
| 65500.07 | 1 | |
| 57912.03 | 1 |
frequency
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 63 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.4378353 |
| Minimum | 1 |
|---|---|
| Maximum | 183 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 13 |
| Maximum | 183 |
| Range | 182 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 7.9617785 |
|---|---|
| Coefficient of variation (CV) | 1.794068 |
| Kurtosis | 149.44434 |
| Mean | 4.4378353 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 9.8882849 |
| Sum | 19025 |
| Variance | 63.389917 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1409 | |
| 2 | 807 | |
| 3 | 522 | 12.2% |
| 4 | 378 | 8.8% |
| 5 | 240 | 5.6% |
| 6 | 188 | 4.4% |
| 7 | 154 | 3.6% |
| 8 | 110 | 2.6% |
| 9 | 79 | 1.8% |
| 10 | 68 | 1.6% |
| Other values (53) | 332 | 7.7% |
| Value | Count | Frequency (%) |
| 1 | 1409 | |
| 2 | 807 | |
| 3 | 522 | 12.2% |
| 4 | 378 | 8.8% |
| 5 | 240 | 5.6% |
| 6 | 188 | 4.4% |
| 7 | 154 | 3.6% |
| 8 | 110 | 2.6% |
| 9 | 79 | 1.8% |
| 10 | 68 | 1.6% |
| Value | Count | Frequency (%) |
| 183 | 1 | |
| 155 | 1 | |
| 135 | 1 | |
| 120 | 1 | |
| 109 | 1 | |
| 97 | 1 | |
| 94 | 1 | |
| 91 | 2 | |
| 89 | 1 | |
| 86 | 1 |
last_visit
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 300 |
|---|---|
| Distinct (%) | 7.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 90.63261 |
| Minimum | 1 |
|---|---|
| Maximum | 374 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 18 |
| median | 52 |
| Q3 | 136 |
| 95-th percentile | 302.7 |
| Maximum | 374 |
| Range | 373 |
| Interquartile range (IQR) | 118 |
Descriptive statistics
| Standard deviation | 96.51785 |
|---|---|
| Coefficient of variation (CV) | 1.0649351 |
| Kurtosis | 0.64998212 |
| Mean | 90.63261 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 1.2950717 |
| Sum | 388542 |
| Variance | 9315.6954 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 97 | 2.3% |
| 15 | 93 | 2.2% |
| 1 | 90 | 2.1% |
| 8 | 79 | 1.8% |
| 4 | 74 | 1.7% |
| 10 | 73 | 1.7% |
| 17 | 71 | 1.7% |
| 9 | 67 | 1.6% |
| 11 | 62 | 1.4% |
| 5 | 62 | 1.4% |
| Other values (290) | 3519 |
| Value | Count | Frequency (%) |
| 1 | 90 | |
| 2 | 97 | |
| 3 | 61 | |
| 4 | 74 | |
| 5 | 62 | |
| 7 | 42 | |
| 8 | 79 | |
| 9 | 67 | |
| 10 | 73 | |
| 11 | 62 |
| Value | Count | Frequency (%) |
| 374 | 7 | |
| 373 | 9 | |
| 372 | 8 | |
| 371 | 6 | |
| 370 | 1 | < 0.1% |
| 369 | 7 | |
| 368 | 10 | |
| 367 | 7 | |
| 366 | 9 | |
| 365 | 8 |
recency
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 373 |
|---|---|
| Distinct (%) | 8.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 135.34173 |
| Minimum | 1 |
|---|---|
| Maximum | 374 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 107 |
| Q3 | 255 |
| 95-th percentile | 359 |
| Maximum | 374 |
| Range | 373 |
| Interquartile range (IQR) | 254 |
Descriptive statistics
| Standard deviation | 132.76003 |
|---|---|
| Coefficient of variation (CV) | 0.98092461 |
| Kurtosis | -1.3514863 |
| Mean | 135.34173 |
| Median Absolute Deviation (MAD) | 106 |
| Skewness | 0.41450077 |
| Sum | 580210 |
| Variance | 17625.227 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1478 | |
| 358 | 26 | 0.6% |
| 370 | 22 | 0.5% |
| 357 | 21 | 0.5% |
| 363 | 21 | 0.5% |
| 360 | 20 | 0.5% |
| 361 | 19 | 0.4% |
| 350 | 19 | 0.4% |
| 359 | 19 | 0.4% |
| 355 | 19 | 0.4% |
| Other values (363) | 2623 |
| Value | Count | Frequency (%) |
| 1 | 1478 | |
| 2 | 5 | 0.1% |
| 3 | 7 | 0.2% |
| 4 | 4 | 0.1% |
| 5 | 5 | 0.1% |
| 6 | 7 | 0.2% |
| 7 | 11 | 0.3% |
| 8 | 2 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 9 | 0.2% |
| Value | Count | Frequency (%) |
| 374 | 5 | 0.1% |
| 373 | 10 | |
| 372 | 14 | |
| 371 | 12 | |
| 370 | 22 | |
| 369 | 14 | |
| 368 | 7 | 0.2% |
| 367 | 15 | |
| 366 | 11 | |
| 365 | 12 |
total_quantity
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 1757 |
|---|---|
| Distinct (%) | 41.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1291.1787 |
| Minimum | 1 |
|---|---|
| Maximum | 220600 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 46 |
| Q1 | 162 |
| median | 386 |
| Q3 | 1001 |
| 95-th percentile | 3440.5 |
| Maximum | 220600 |
| Range | 220599 |
| Interquartile range (IQR) | 839 |
Descriptive statistics
| Standard deviation | 6476.3168 |
|---|---|
| Coefficient of variation (CV) | 5.0158176 |
| Kurtosis | 520.83429 |
| Mean | 1291.1787 |
| Median Absolute Deviation (MAD) | 286 |
| Skewness | 20.243455 |
| Sum | 5535283 |
| Variance | 41942679 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 60 | 19 | 0.4% |
| 72 | 18 | 0.4% |
| 48 | 17 | 0.4% |
| 96 | 17 | 0.4% |
| 108 | 16 | 0.4% |
| 74 | 15 | 0.3% |
| 144 | 15 | 0.3% |
| 100 | 14 | 0.3% |
| 24 | 14 | 0.3% |
| 138 | 13 | 0.3% |
| Other values (1747) | 4129 |
| Value | Count | Frequency (%) |
| 1 | 9 | |
| 2 | 3 | 0.1% |
| 3 | 5 | |
| 4 | 2 | < 0.1% |
| 5 | 5 | |
| 6 | 5 | |
| 7 | 1 | < 0.1% |
| 8 | 2 | < 0.1% |
| 10 | 4 | |
| 11 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 220600 | 1 | |
| 170278 | 1 | |
| 125893 | 1 | |
| 124216 | 1 | |
| 108076 | 1 | |
| 87829 | 1 | |
| 87167 | 1 | |
| 75824 | 1 | |
| 69637 | 1 | |
| 63551 | 1 |
total_unique_items
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 346 |
|---|---|
| Distinct (%) | 8.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 63.930488 |
| Minimum | 1 |
|---|---|
| Maximum | 1737 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 17 |
| median | 38 |
| Q3 | 80 |
| 95-th percentile | 203 |
| Maximum | 1737 |
| Range | 1736 |
| Interquartile range (IQR) | 63 |
Descriptive statistics
| Standard deviation | 85.757359 |
|---|---|
| Coefficient of variation (CV) | 1.3414157 |
| Kurtosis | 78.30722 |
| Mean | 63.930488 |
| Median Absolute Deviation (MAD) | 26 |
| Skewness | 6.1435101 |
| Sum | 274070 |
| Variance | 7354.3246 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 89 | 2.1% |
| 23 | 80 | 1.9% |
| 13 | 78 | 1.8% |
| 16 | 77 | 1.8% |
| 11 | 75 | 1.7% |
| 19 | 68 | 1.6% |
| 14 | 68 | 1.6% |
| 8 | 66 | 1.5% |
| 6 | 66 | 1.5% |
| 7 | 65 | 1.5% |
| Other values (336) | 3555 |
| Value | Count | Frequency (%) |
| 1 | 89 | |
| 2 | 55 | |
| 3 | 45 | |
| 4 | 61 | |
| 5 | 63 | |
| 6 | 66 | |
| 7 | 65 | |
| 8 | 66 | |
| 9 | 62 | |
| 10 | 56 |
| Value | Count | Frequency (%) |
| 1737 | 1 | |
| 1507 | 1 | |
| 1339 | 1 | |
| 1091 | 1 | |
| 1084 | 1 | |
| 712 | 1 | |
| 654 | 1 | |
| 646 | 1 | |
| 606 | 1 | |
| 593 | 1 |
total_items
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 471 |
|---|---|
| Distinct (%) | 11.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.945883 |
| Minimum | 1 |
|---|---|
| Maximum | 5485 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 18.5 |
| median | 44 |
| Q3 | 103 |
| 95-th percentile | 323.7 |
| Maximum | 5485 |
| Range | 5484 |
| Interquartile range (IQR) | 84.5 |
Descriptive statistics
| Standard deviation | 201.6959 |
|---|---|
| Coefficient of variation (CV) | 2.1243248 |
| Kurtosis | 257.87163 |
| Mean | 94.945883 |
| Median Absolute Deviation (MAD) | 32 |
| Skewness | 12.625668 |
| Sum | 407033 |
| Variance | 40681.235 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13 | 78 | 1.8% |
| 1 | 75 | 1.7% |
| 12 | 66 | 1.5% |
| 6 | 65 | 1.5% |
| 11 | 63 | 1.5% |
| 9 | 63 | 1.5% |
| 16 | 63 | 1.5% |
| 18 | 62 | 1.4% |
| 23 | 60 | 1.4% |
| 21 | 60 | 1.4% |
| Other values (461) | 3632 |
| Value | Count | Frequency (%) |
| 1 | 75 | |
| 2 | 49 | |
| 3 | 38 | |
| 4 | 56 | |
| 5 | 56 | |
| 6 | 65 | |
| 7 | 60 | |
| 8 | 59 | |
| 9 | 63 | |
| 10 | 52 |
| Value | Count | Frequency (%) |
| 5485 | 1 | |
| 5041 | 1 | |
| 3857 | 1 | |
| 2617 | 1 | |
| 2615 | 1 | |
| 2499 | 1 | |
| 2269 | 1 | |
| 2052 | 1 | |
| 1773 | 1 | |
| 1726 | 1 |
last_purchase
Date
| Distinct | 4162 |
|---|---|
| Distinct (%) | 97.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 33.6 KiB |
| Minimum | 2009-12-01 09:55:00 |
|---|---|
| Maximum | 2010-12-09 20:01:00 |
first_purchase
Date
| Distinct | 4190 |
|---|---|
| Distinct (%) | 97.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 33.6 KiB |
| Minimum | 2009-12-01 07:45:00 |
|---|---|
| Maximum | 2010-12-09 16:08:00 |
| Distinct | 1118 |
|---|---|
| Distinct (%) | 26.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 33.6 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 5.1182645 |
| Min length | 4 |
Characters and Unicode
| Total characters | 21942 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 533 ? |
|---|---|
| Unique (%) | 12.4% |
Sample
| 1st row | 15056BL |
|---|---|
| 2nd row | 84558A |
| 3rd row | 21211 |
| 4th row | 16156S |
| 5th row | 20886 |
| Value | Count | Frequency (%) |
| 85123a | 121 | 2.8% |
| 21034 | 76 | 1.8% |
| 20914 | 64 | 1.5% |
| 21232 | 62 | 1.4% |
| post | 61 | 1.4% |
| 20725 | 59 | 1.4% |
| 20685 | 58 | 1.4% |
| 21754 | 47 | 1.1% |
| 15036 | 39 | 0.9% |
| 22423 | 36 | 0.8% |
| Other values (1108) | 3664 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 5314 | |
| 1 | 3605 | |
| 0 | 2254 | |
| 7 | 1653 | 7.5% |
| 5 | 1591 | 7.3% |
| 8 | 1523 | 6.9% |
| 4 | 1365 | 6.2% |
| 6 | 1315 | 6.0% |
| 3 | 1277 | 5.8% |
| 9 | 1233 | 5.6% |
| Other values (19) | 812 | 3.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21942 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 5314 | |
| 1 | 3605 | |
| 0 | 2254 | |
| 7 | 1653 | 7.5% |
| 5 | 1591 | 7.3% |
| 8 | 1523 | 6.9% |
| 4 | 1365 | 6.2% |
| 6 | 1315 | 6.0% |
| 3 | 1277 | 5.8% |
| 9 | 1233 | 5.6% |
| Other values (19) | 812 | 3.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21942 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 5314 | |
| 1 | 3605 | |
| 0 | 2254 | |
| 7 | 1653 | 7.5% |
| 5 | 1591 | 7.3% |
| 8 | 1523 | 6.9% |
| 4 | 1365 | 6.2% |
| 6 | 1315 | 6.0% |
| 3 | 1277 | 5.8% |
| 9 | 1233 | 5.6% |
| Other values (19) | 812 | 3.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21942 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 5314 | |
| 1 | 3605 | |
| 0 | 2254 | |
| 7 | 1653 | 7.5% |
| 5 | 1591 | 7.3% |
| 8 | 1523 | 6.9% |
| 4 | 1365 | 6.2% |
| 6 | 1315 | 6.0% |
| 3 | 1277 | 5.8% |
| 9 | 1233 | 5.6% |
| Other values (19) | 812 | 3.7% |
| customer_id | frequency | last_visit | monatary | recency | total_items | total_quantity | total_unique_items | |
|---|---|---|---|---|---|---|---|---|
| customer_id | 1.000 | -0.002 | -0.017 | -0.084 | -0.009 | 0.001 | -0.068 | 0.001 |
| frequency | -0.002 | 1.000 | -0.526 | 0.828 | 0.887 | 0.744 | 0.775 | 0.672 |
| last_visit | -0.017 | -0.526 | 1.000 | -0.461 | -0.538 | -0.469 | -0.433 | -0.431 |
| monatary | -0.084 | 0.828 | -0.461 | 1.000 | 0.740 | 0.794 | 0.938 | 0.744 |
| recency | -0.009 | 0.887 | -0.538 | 0.740 | 1.000 | 0.664 | 0.689 | 0.606 |
| total_items | 0.001 | 0.744 | -0.469 | 0.794 | 0.664 | 1.000 | 0.768 | 0.985 |
| total_quantity | -0.068 | 0.775 | -0.433 | 0.938 | 0.689 | 0.768 | 1.000 | 0.723 |
| total_unique_items | 0.001 | 0.672 | -0.431 | 0.744 | 0.606 | 0.985 | 0.723 | 1.000 |
| customer_id | monatary | frequency | last_visit | recency | total_quantity | total_unique_items | total_items | last_purchase | first_purchase | most_purchase_item | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 12346.00 | 169.36 | 2 | 165 | 119 | 24 | 24 | 24 | 2010-06-28 13:53:00 | 2010-03-02 13:08:00 | 15056BL |
| 1 | 12347.00 | 1323.32 | 2 | 3 | 38 | 828 | 70 | 71 | 2010-12-07 14:57:00 | 2010-10-31 14:20:00 | 84558A |
| 2 | 12348.00 | 222.16 | 1 | 74 | 1 | 373 | 20 | 20 | 2010-09-27 14:59:00 | 2010-09-27 14:59:00 | 21211 |
| 3 | 12349.00 | 2671.14 | 3 | 43 | 182 | 993 | 90 | 102 | 2010-10-28 08:23:00 | 2010-04-29 13:20:00 | 16156S |
| 4 | 12351.00 | 300.93 | 1 | 11 | 1 | 261 | 21 | 21 | 2010-11-29 15:23:00 | 2010-11-29 15:23:00 | 20886 |
| 5 | 12352.00 | 343.80 | 2 | 11 | 17 | 188 | 18 | 18 | 2010-11-29 10:07:00 | 2010-11-12 10:20:00 | 21121 |
| 6 | 12353.00 | 317.76 | 1 | 44 | 1 | 192 | 20 | 20 | 2010-10-27 12:44:00 | 2010-10-27 12:44:00 | 20617 |
| 7 | 12355.00 | 488.21 | 1 | 203 | 1 | 303 | 22 | 22 | 2010-05-21 11:59:00 | 2010-05-21 11:59:00 | 20818 |
| 8 | 12356.00 | 3562.25 | 3 | 16 | 45 | 1826 | 68 | 84 | 2010-11-24 12:24:00 | 2010-10-11 09:42:00 | 16156S |
| 9 | 12357.00 | 12079.99 | 2 | 24 | 1 | 3879 | 165 | 165 | 2010-11-16 14:29:00 | 2010-11-16 10:05:00 | 10002 |
| customer_id | monatary | frequency | last_visit | recency | total_quantity | total_unique_items | total_items | last_purchase | first_purchase | most_purchase_item | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4277 | 18277.00 | 1069.67 | 4 | 33 | 98 | 381 | 48 | 56 | 2010-11-07 15:52:00 | 2010-08-02 10:26:00 | 15056BL |
| 4278 | 18278.00 | 240.30 | 1 | 40 | 1 | 74 | 15 | 15 | 2010-10-31 12:13:00 | 2010-10-31 12:13:00 | 20914 |
| 4279 | 18279.00 | 231.34 | 1 | 155 | 1 | 630 | 13 | 13 | 2010-07-08 14:48:00 | 2010-07-08 14:48:00 | 17003 |
| 4280 | 18280.00 | 307.55 | 1 | 30 | 1 | 149 | 20 | 20 | 2010-11-10 15:51:00 | 2010-11-10 15:51:00 | 21114 |
| 4281 | 18281.00 | 120.32 | 1 | 213 | 1 | 92 | 10 | 10 | 2010-05-11 10:49:00 | 2010-05-11 10:49:00 | 20719 |
| 4282 | 18283.00 | 641.77 | 6 | 18 | 276 | 336 | 158 | 230 | 2010-11-22 15:30:00 | 2010-02-19 17:16:00 | 20727 |
| 4283 | 18284.00 | 411.68 | 1 | 67 | 1 | 493 | 27 | 27 | 2010-10-04 11:33:00 | 2010-10-04 11:33:00 | 16237 |
| 4284 | 18285.00 | 377.00 | 1 | 296 | 1 | 144 | 11 | 11 | 2010-02-17 10:24:00 | 2010-02-17 10:24:00 | 20802 |
| 4285 | 18286.00 | 1246.43 | 2 | 112 | 248 | 607 | 66 | 66 | 2010-08-20 11:57:00 | 2009-12-16 10:45:00 | 10135 |
| 4286 | 18287.00 | 2295.71 | 4 | 18 | 189 | 1426 | 76 | 84 | 2010-11-22 11:51:00 | 2010-05-17 11:55:00 | 22064 |